MYSQL DateTime Now()+5 days/hours/minutes/seconds?

Question

I am looking for a way to when inserting into mysql using now() to modify the datetime.

eg

updateuserssetexpires= NOW()+5days where...

Answer 1

update users set expires=  NOW() + interval 5 day where ...;