UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D7MSMnPclE0A84IO/b/IdfeyC3qpefS2/vGTD9J6XXk='
WHERE
key_id = 'd6e18318a82e3779d0b4eeb1e156c30f5e94206e878d19d025804c5b41574b1a'
AND (
token = 'D7MSMnPclE0A84IO/b/IdfeyC3qpefS2/vGTD9J6XXk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)