UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3htqau8tqmxF3t0TDZxav+j0kORyAf+uvtR0Dt/gsy0='
WHERE
key_id = '1ba7aef4fa2c727c0475c9cbd8ca671279f0928f0aa22ec4a902efa97f2472df'
AND (
token = '3htqau8tqmxF3t0TDZxav+j0kORyAf+uvtR0Dt/gsy0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)