MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table scores (
  id int,
  name varchar(25),
  datetime_added timestamp,
  `option` varchar(10)
) ;

insert into scores values 

(1,'all','2023-01-01 00:10:04','none'),
(2,'James','2023-01-01 00:32:18','none'),
(3,'all','2023-01-01 02:08:51','none'),
(4,'all','2023-01-01 04:13:07','none'),
(5,'Rubio','2023-01-01 07:05:55','none'),
(6,'all','2023-01-01 09:17:27','none'),
(7,'James','2023-01-01 10:43:01','none');

Records: 7  Duplicates: 0  Warnings: 0


select * from scores


id
name
datetime_added
option


1
all
2023-01-01 00:10:04
none

2
James
2023-01-01 00:32:18
none

3
all
2023-01-01 02:08:51
none

4
all
2023-01-01 04:13:07
none

5
Rubio
2023-01-01 07:05:55
none

6
all
2023-01-01 09:17:27
none

7
James
2023-01-01 10:43:01
none


WITH ToUpdate AS 
(
 select id,
         row_number() over( order by case when name='Rubio' and `option`='none' then 1 
                when name ='all' and `option`='none' then 2 
                else 3 end  asc,datetime_added desc ) row_num
  from scores
  where `option`='none' 
  and name in ('all','Rubio')
)   
UPDATE scores  
INNER JOIN  ToUpdate  ON scores.id = ToUpdate.id
SET  `option` = 'some' 
WHERE ToUpdate.row_num = 1; 

Rows matched: 1  Changed: 1  Warnings: 0


select * from scores;


id
name
datetime_added
option


1
all
2023-01-01 00:10:04
none

2
James
2023-01-01 00:32:18
none

3
all
2023-01-01 02:08:51
none

4
all
2023-01-01 04:13:07
none

5
Rubio
2023-01-01 07:05:55
some

6
all
2023-01-01 09:17:27
none

7
James
2023-01-01 10:43:01
none

id	name	datetime_added	option
1	all	2023-01-01 00:10:04	none
2	James	2023-01-01 00:32:18	none
3	all	2023-01-01 02:08:51	none
4	all	2023-01-01 04:13:07	none
5	Rubio	2023-01-01 07:05:55	none
6	all	2023-01-01 09:17:27	none
7	James	2023-01-01 10:43:01	none