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