If your stored procedure having loop and based on their iteration if time elapsed then you cannot change for time out expiration without changing SQL timeout option as it’s based on your SQL query execution time and timeout expiry limit. Refer the below link for your reference to set SQL Timeout option.

SQl Server still getting the error of “Timeout expired. The timeout period elapsed”