Chennai Super Kings' losing streak came to an end with a dramatic last-over win against Lucknow Super Giants.