MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE goods (
  id int NOT NULL ,
  name varchar(25) ,
  updateat datetime,
  PRIMARY KEY (id, name)
)
insert into goods values (1, 'john', '2021-01-02');
select * from goods;


id
name
updateat


1
john
2021-01-02 00:00:00


insert into goods (id, name, updateat)
 values (1, 'jane', '2021-01-03')
 ON DUPLICATE KEY UPDATE 
 updateat = greatest('2021-01-03', (select updateat from (select * from goods as g) as g where id = 1))
select * from goods;


id
name
updateat


1
jane
2021-01-03 00:00:00

1
john
2021-01-02 00:00:00