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