UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f0ZBtAMmTqFaxNgEKdSGgk6alGTPPJFMbb3HSH3o7GU='
WHERE
key_id = '9ff665e74d0cb64cc2682eff056ab6fe452cb7b4a7279b90df7cd500f58a5e8b'
AND (
token = 'f0ZBtAMmTqFaxNgEKdSGgk6alGTPPJFMbb3HSH3o7GU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)