MySQL在插入新字段时自动添加日期和时间字段

My Database DDL is below

CREATE TABLE `user` (
  `token` text NOT NULL,
  `country` text NOT NULL,
  `timezone` text NOT NULL,
  `date_registered` date NOT NULL,
  `time_registered` timestamp NOT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

How can I make it so that whenever a new record is created that the date and time will automatically be generated and inserted without relying on PHP to add an extra variable for me to process?

http://example.com/webapps/api/add_token.php?token=%@&country=%@&timezone=%@

The @% are variables generated at run time from my iOS application.

Before a row was generating when I ran my application. But I added two new fields (date_registered and time_registered) and now it is not adding data to the table