Develop a redirect script on PHP (Laravel) MySL

How it works:

By exit: url/client_id/patient_id

The script does:
1) Redirect to a random link from the table redirect_urls
2) writes down review_click data on perfect redirect

Database:

Table: redirect_urls:
ID | URL | Active

Table: review_click
CLIENT_ID | URL_ID | PATIENT_ID | TIME