Any suggestions on how I played this hand?

[Abeatdown]

Cash home game with .50/100 blinds. Started with $100, I currently had $310 when this hand begins and we are playing 6 handed as a few have busted out and left.

I'm BB with 68o when 4 limp to me, so I check. $5 in the pot.

Flop comes 10 9 7 rainbow flopping me the straight. UTG with only $5 in the pot I check knowing a few players behind me are likely to bet. No one bets though and it checks around.

Turn is Q putting 2 clubs on the board. I bet $4 into the $5 pot 2 players fold, then Button raises to $8. Pot now $17. I reraise $25, and he calls the additional $25.

River is Ace, no club. I lead out $25 and he goes all in. Now here I am fairly certain he either had a set or KJ and most likely had KJ. The Ace is meaning less for KJ as he had the straight on the turn if he had it. But considering he didnt raise me on the turn with 2 clubs on the board, I decided to call thinking he was playing his set scared as he often doesnt reraise big hands as he is worried of being drawn out on. At the same time, I know he doesnt put all his chips in without a big hand putting me in a bad spot.

It was an additional call of $121 to me after he puts in the $25. I call, he shows KJ clubs, meaning he had the better straight on the turn plus the Club draw going into the river (which he didnt hit).

I was mad at myself for calling when I knew I was beat...but like I usually do, I tried to convince myself that there were hands I could beat here and with all that money in the pot I should call, and of course I did.

I immediately started trying to figure out how I could have played this hand different to change the outcome. Would you have bet the flop? To be honest, with so little money in the pot he said he would have called any flop bet with 2 overcards and inside straight draw in an unraised pot PF so even if I bet the flop (unless I make a gross overbet of the pot) I just dont see it changing anything.

So I guess, I could have just folded on the river...what do you think?

This hand knocked me down to $130 or so but I still ended the night with almost $300 by nights end 2 hours or so later, but this hand is the one thats bugging me as I feel like I played great most the night except for this hand.