UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9JTRGAVZvz76lyMb7iNiIy/LGh8yxCIlabbegW5iFRI='
WHERE
key_id = '6098d1f2e13df6184147b079c8bb7d0663fcfa5547efbfbe001ea2215618a269'
AND (
token = '9JTRGAVZvz76lyMb7iNiIy/LGh8yxCIlabbegW5iFRI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)