UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a/d4IfBJbSH2M0AT+VkOa6miKC6f2i5rAhoEW/iMgZU='
WHERE
key_id = '8c033681b11b84c0d02c0feba69687ff05ba3a0ef5b40b4898bfe095095ded97'
AND (
token = 'a/d4IfBJbSH2M0AT+VkOa6miKC6f2i5rAhoEW/iMgZU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)