UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XN+yCl4V+ThbN09ZYO146kspt7qJmh2VMsCrzvEdXhU='
WHERE
key_id = 'f6c67c76fb6fd353177963aaa2941b7f952bdd49f1340d2b760c0fbc0a0d013c'
AND (
token = 'XN+yCl4V+ThbN09ZYO146kspt7qJmh2VMsCrzvEdXhU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)