UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nxKH9F4LtYEcHiP050/9kDJJ5hiSRoDQIwIF4R7217Y='
WHERE
key_id = '026db5b18e02fe4ed63d60bfff69ed612b6469317c812b75525f0940a4171ed1'
AND (
token = 'nxKH9F4LtYEcHiP050/9kDJJ5hiSRoDQIwIF4R7217Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)