update
   GOODS
set
   SALE_END_DATE = '2024-07-31'
where
    VALID_FLG     = '0'
and SALE_END_DATE is null
;