I don't normally use mirror lock up for macro photography, but that's not to say it's a pointless thing. I would recommend using it if you have it as it can't hurt, but if you don't have it, I wouldn't recommend spending loads of money to get it unless there's an issue with your macro shots which is related to vibration.
Rob