UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QbXqyfseCqN9/TvfuZRKe7fLGHL+aLwE5c96b+okmEY='
WHERE
key_id = 'e5efab0f7188e4f9435092303fc78ef356f304c794ebf7dae9f7a867c575a59b'
AND (
token = 'QbXqyfseCqN9/TvfuZRKe7fLGHL+aLwE5c96b+okmEY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)