UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kXSv8YfrrkZ512fvyh/WAUqUcTpO6h585c6DH7p9bT4='
WHERE
key_id = 'f68acf4dbd34007e7bab9fac1213b81940608c11344103c2ea8dec8547d1a8eb'
AND (
token = 'kXSv8YfrrkZ512fvyh/WAUqUcTpO6h585c6DH7p9bT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)