UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZghCIsP2xf8mGienDD9dyFc8aLMeTI1FYirWGv9L9Rc='
WHERE
key_id = '6698a57e0ee62df56243f125f76079c612353ffeedabb1e7f8635ca7d9d2c5b2'
AND (
token = 'ZghCIsP2xf8mGienDD9dyFc8aLMeTI1FYirWGv9L9Rc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)