UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'on49FXwznFOT8I1jdxtzfBXNEoZytrPoDGEhs2HPivw='
WHERE
key_id = '47baa1a6ccd0d0abeb08b979b211bd715249c2ac28e6ed4634f0100da0c9e47a'
AND (
token = 'on49FXwznFOT8I1jdxtzfBXNEoZytrPoDGEhs2HPivw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)