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