SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '9a0d0dfea6f226cc722525b924e981ce10e1755313a4097d3ed41b5166a8f4e4' 
  AND token = 'n1jpCiK99/53LbteMubh8T1yQE+ZLnYy57hp1jDOm20=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00036

JSON explain

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