UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4rrtC0Sl1RSHhuqih8qCaYqkoTJdcdYPAzmVst17rG0='
WHERE
key_id = 'd6ac5c8d25ee2ae8e70f8003b96f57ea360f3f04968209a8de2529bd1ede1561'
AND (
token = '4rrtC0Sl1RSHhuqih8qCaYqkoTJdcdYPAzmVst17rG0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)