UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5gnfyb4A3lI1QBQLxhWkrtwU8/a4574qLXaRji7Y1rY='
WHERE
key_id = '08364a70b5a6a24f7da53b0b45ebeda9c218d090824388ecc4b2a6d20b3f6811'
AND (
token = '5gnfyb4A3lI1QBQLxhWkrtwU8/a4574qLXaRji7Y1rY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)