Use this "alter query" if you want to add a new column with the mentioned scenario

ALTER TABLE Table_Name
  add COLUMN DateTime_Column_Name TIMESTAMP NULL 
  DEFAULT NULL 
  ON UPDATE CURRENT_TIMESTAMP;