update
    goods
set
    sale_end_date = '2024-07-31'
WHERE
    valid_flg = '0'
    AND sale_end_date IS NULL;
    
select
    sale_end_date
from
    goods
where
    valid_flg = '0'
    AND sale_end_date IS NULL;