How do you convert between Unix timestamps and MySQL timestamps?

UNIX_TIMESTAMP converts from MySQL timestamp to Unix timestamp,
FROM_UNIXTIME converts from Unix timestamp to MySQL timestamp.