Values within the last 5 minutes:

SELECT value FROM table WHERE value > DATE_SUB(NOW(), INTERVAL 5 MINUTE)

Values older than 1 month:

SELECT value FROM table WHERE value < DATE_SUB(NOW(), INTERVAL 1 MONTH)