UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mnC8n+bnOfo6+3FH31HcBQvTZ6oNZ2CjsynB8K51i04='
WHERE
key_id = '96b7cdd13bd2ff5df8de6ac06646d53a7c2de4cf0761123336d5b6cd2c37dff6'
AND (
token = 'mnC8n+bnOfo6+3FH31HcBQvTZ6oNZ2CjsynB8K51i04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)