UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HuX0h/fPuUe/5ZeGa79lI4Id2yD1f6wZsgMYKn1ZdlY='
WHERE
key_id = '47b491f3e2292ffcb3db1be2aaca43b83005753efd72e512088167110cfa8734'
AND (
token = 'HuX0h/fPuUe/5ZeGa79lI4Id2yD1f6wZsgMYKn1ZdlY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)