update mytable
  set right_now=DATE_ADD('1970-01-01', INTERVAL UNIX_TIMESTAMP() SECOND)