update payments
set created_at=DATE_SUB(created_at, INTERVAL 3600 MINUTE)
where created_at between "2018-01-06 17:59:00" and "2018-01-07 07:00:00";
update payments
set updated_at=DATE_SUB(updated_at, INTERVAL 3600 MINUTE)
where updated_at between "2018-01-06 17:59:00" and "2018-01-07 07:00:00";
update payment_transactions
set created_at=DATE_SUB(created_at, INTERVAL 3600 MINUTE)
where created_at between "2018-01-06 17:59:00" and "2018-01-07 07:00:00";
update payment_transactions
set updated_at=DATE_SUB(updated_at, INTERVAL 3600 MINUTE)
where updated_at between "2018-01-06 17:59:00" and "2018-01-07 07:00:00";