UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2x1iIUcn4uyVtz9VJQApGknQ71VBoMPpHRluI9zsIkc='
WHERE
key_id = '9c7154e8b55dfc4c5825307deab0778c0b4794b330f391a13626f8eec90009a6'
AND (
token = '2x1iIUcn4uyVtz9VJQApGknQ71VBoMPpHRluI9zsIkc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)