UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gNrForBtOgMF3yU4iJYmRf9edpElxo0l6Wka4gRAvNU='
WHERE
key_id = 'c6681dec2f8636e28f342d1514fcce33c61ee48866d7c39e6c3717635cbe4e5e'
AND (
token = 'gNrForBtOgMF3yU4iJYmRf9edpElxo0l6Wka4gRAvNU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)