UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a4wxYPTJbuZoljEdWvjeVY04HDkfTCOUP2JT6JQyTVY='
WHERE
key_id = 'a0524f1665abde16650cb2a155483d963dafb7a8e8737965a7bdd1b8f872f598'
AND (
token = 'a4wxYPTJbuZoljEdWvjeVY04HDkfTCOUP2JT6JQyTVY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)