UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q+ridIZSy6jTIx99c9faPVrWvDeZ9C1L/LydkUhm6xw='
WHERE
key_id = 'fcfe188e98290892d6b86ca77e6aafac4814a1d8c33a6775fc3db3c068ef2cc9'
AND (
token = 'q+ridIZSy6jTIx99c9faPVrWvDeZ9C1L/LydkUhm6xw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)