INSERT or UPDATE row to be Now + # Days

Now() + INTERVAL $no_of_days DAY,

Some of the values you can use:

DAY
HOUR
MINUTE
MONTH
SECOND
WEEK
YEAR

Update a DateTime with a random value

SET LastActive = NOW() - INTERVAL ROUND(RAND() * 72) HOUR WHERE