update
    goods
set
    sale_end_date = '2024-07-31'
where
    valid_flg = '0'
and sale_end_date is null;

select
    *
from
    goods