UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a/U7arswTqeM9jVcIof7umzteG3rjj82LTTt744R0QU='
WHERE
key_id = 'bbf4ef0aa686a54ad7391de8fe74d763eec997b330ee242a2ea4fc5f54d4aee6'
AND (
token = 'a/U7arswTqeM9jVcIof7umzteG3rjj82LTTt744R0QU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)