UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tm7jUUvR3UTV3o42BnDg2NUlWqvCQA5U9HvyO6wTnQA='
WHERE
key_id = 'ca8d4174438003d8891314e72fda6e6a3bd28f6f69e639b469e69bba3eda4141'
AND (
token = 'tm7jUUvR3UTV3o42BnDg2NUlWqvCQA5U9HvyO6wTnQA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)