insert into
    GOODS
values
    (
        case
            when VALID_FLG = '0'
            AND SALE_END_DATE is NULL THEN SALE_END_DATE = '2024-07-31'
        end
    );