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