UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cQUjyVkpu0Vf6D6ZDyVZK4ar4LznbSjFXyUZeCjPAL8='
WHERE
key_id = '5db2a1cf6b030e3b5b56a2df9147ce846a7ff3ec2072a079ee84b678492b36bd'
AND (
token = 'cQUjyVkpu0Vf6D6ZDyVZK4ar4LznbSjFXyUZeCjPAL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)