SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '02902b03ed15f40444954ad1ade48e9f317e017de684336af5dc0277799fb7f0' 
  AND token = 'CUg/mF7eneVlxpmRV0EdBQ6O3J8cUlTttLh5glaA9ds=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00025

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}