UPDATE sensor_readings SET timestamp = DATE_ADD(DATE_ADD(timestamp, INTERVAL 7 DAY), INTERVAL 2 HOUR) WHERE 1;