UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'koJqye3zlc3wouX3qmOd4n2k6nPNZOdJSIEUmRf9n+8='
WHERE
key_id = 'a3ed8bc111e1ac4338eb50706ce11b2673c3605ad56235d1a08aba0a39cd7159'
AND (
token = 'koJqye3zlc3wouX3qmOd4n2k6nPNZOdJSIEUmRf9n+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)