UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ESXYKXpRXkRW69YTDKTMyLp9FcFvN2rbZSi1XYAlcYs='
WHERE
key_id = 'f532c67ae683b8184373d4447548ab39be6fb4201bd5020387edffce4e801bab'
AND (
token = 'ESXYKXpRXkRW69YTDKTMyLp9FcFvN2rbZSi1XYAlcYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)