UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'waMkfhwR7ySw5UEHXjGkNyCTHFIlwi44LfN2WiL1Y9Q='
WHERE
key_id = '3a5226c40dec2ab7dd290f3af84e2611daf49417a72c66a537d834f46ad21a6b'
AND (
token = 'waMkfhwR7ySw5UEHXjGkNyCTHFIlwi44LfN2WiL1Y9Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)