UPDATE account set gold_expire = DATE_ADD(gold_expire,INTERVAL 7 DAY), money_drop_rate_expire = DATE_ADD(money_drop_rate_expire,INTERVAL 7 DAY), silver_expire = DATE_ADD(silver_expire,INTERVAL 7 DAY) WHERE gold_expire > NOW();
UPDATE account set gold_expire = DATE_ADD(NOW(),INTERVAL 7 DAY), money_drop_rate_expire = DATE_ADD(NOW(),INTERVAL 7 DAY), silver_expire = DATE_ADD(NOW(),INTERVAL 7 DAY) where gold_expire < NOW();