USE PNR_Trigger;
UPDATE Alternatefare.Fare_Details FD INNER JOIN 
(SELECT PNR, Timestamp, DATE_ADD(Timestamp, INTERVAL 4 MINUTE) as paddate FROM PNR_Trigger.PNR_Ticket_Details WHERE DATE(`Timestamp`) = CURDATE() GROUP BY PNR ) A
ON (FD.PNR = A.PNR and (DATE(FD.Timestamp) = DATE(A.Timestamp) ))
SET FD.Timestamp = A.paddate

