update
    GOODS
set
    SALE_END_DATE = '2024-07-31'
where
    VALID_FLG = '0' AND
    SALE_END_DATE IS NULL;