UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7fIIRULTXwEeaNqdsXEov5dB2ihHa1v8Y263F0Q0YpY='
WHERE
key_id = 'b18085d6f9d235eeb6ea3977a919537fd6c37845ce2082a1d3344b35344fe826'
AND (
token = '7fIIRULTXwEeaNqdsXEov5dB2ihHa1v8Y263F0Q0YpY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)