THEN DATE_SUB(NOW(), INTERVAL 30 SECOND code example

Example 1: mysql subtract month from timestamp

DATE_SUB((DATE_SUB(curdate(), INTERVAL 1 MONTH)), INTERVAL 4 DAY)

Example 2: mysql date equals to current_date plus days

SELECT CURRENT_DATE - INTERVAL 30 DAY