MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


5.7.35


CREATE TABLE `goods` (
  `id` int NOT NULL ,
  `name` varchar(25) ,
  `updateat` datetime 
);


-- use a unique index if you are interested in ensuring a subset of columns are unique and 
-- these columns do not meet the criteria to be a primary/composite key based on your database design
create unique index uk_id_name on  goods(id,name);
insert into goods values (1,'new','2021-12-18 12:00:00');

-- this should fail because of the duplicate unique index
insert into goods values (1,'new','2021-12-18 12:00:00');
Duplicate entry '1-new' for key 'uk_id_name'

select * from goods;



id
name
updateat


1
new
2021-12-18 12:00:00


insert into goods values (1,'new','2021-12-18 12:00:01')
on duplicate key update updateat= CASE 
   WHEN updateat > VALUES(updateat) THEN updateat
   ELSE VALUES(updateat)
END;

select * from goods;


id
name
updateat


1
new
2021-12-18 12:00:01