UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1R6iTCInhZIvbIM/a1Y9k9Z//cF43T34wOEJca/MWIU='
WHERE
key_id = '5b85b194bee8579d1aaad4af2d37223cc67a2963ae93e8872ea559dfd863394f'
AND (
token = '1R6iTCInhZIvbIM/a1Y9k9Z//cF43T34wOEJca/MWIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)