UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rfc7plBiXKDy4pk9EG4xWJOCyvdVFfOzukUutgK2NFs='
WHERE
key_id = '3672e5223930244a29cf59b11bc073c4dc4ba112d466c319a716050db997d376'
AND (
token = 'rfc7plBiXKDy4pk9EG4xWJOCyvdVFfOzukUutgK2NFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)