UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zpmsgJcpMm9jI72ZxJIEg730liwCeSJe7xrOWIj2bwo='
WHERE
key_id = '1463a312e93c54b248c2c88cd92f47759b7ab6beb871776192a566450004286b'
AND (
token = 'zpmsgJcpMm9jI72ZxJIEg730liwCeSJe7xrOWIj2bwo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)