Depends on the situation. If they have more time right then and there, why wasn’t that included in the roll I already asked for? If they said, “I’m only going to try for about an hour”, I’m going to probably hold them to that. We agreed on a resolution model, and they aren’t going to game it just because they failed a check. Next time, we can use a different model, if they didn't like how this one played out.
Now, if they go do something else that they were planning on doing anyway, and still have time to go back to the lock, say that evening, I’ll let them decide how long they spend working on it this time, and ask for a new roll. Depending on the task, I may even apply advantage on this check, because they’ve cleared their head and they know the task better than they did before. IRL, I often find such “after a break and completing some other task” attempts to inexplicably be trivially easy compared to the first attempt.
I’m not any other poster. I don’t insist on any sort of strict “must use a new approach” stuff.
Every skill check abstracts that same thing.