Try This.
UPDATE tblFavorite
SET
tblFavorite.ItemID=tblFavoritetemp.ItemID,
tblFavorite.ItemTitle = tblFavoritetemp.ItemTitle,
FROM tblFavoritetemp
WHERE
tblFavorite.CategoryID = tblFavoritetemp.CategoryID
AND
CASE WHEN (tblFavorite.ExDate <> null) THEN DATEDIFF(minute, tblFavorite.ExDate, GETDATE())) ELSE 0 END <= 0
Hope this will help you.